SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

/*
----------------------------------------------------------------------------------------------------

-- Created By:  ()
-- Purpose: Updates a record in the MessageConfig table
----------------------------------------------------------------------------------------------------
*/


CREATE PROCEDURE dbo.MessageConfig_Update
(

	@KeyCode varchar (15)  ,

	@OriginalKeyCode varchar (15)  ,

	@Value nvarchar (200)  ,

	@TypeId int   ,

	@Language varchar (10)  ,

	@CreatedDate datetime   ,

	@UpdatedDate datetime   ,

	@CreatedUser varchar (50)  ,

	@UpdatedUser varchar (50)  
)
AS


				
				
				-- Modify the updatable columns
				UPDATE
					[dbo].[MessageConfig]
				SET
					[KeyCode] = @KeyCode
					,[Value] = @Value
					,[TypeId] = @TypeId
					,[Language] = @Language
					,[CreatedDate] = @CreatedDate
					,[UpdatedDate] = @UpdatedDate
					,[CreatedUser] = @CreatedUser
					,[UpdatedUser] = @UpdatedUser
				WHERE
[KeyCode] = @OriginalKeyCode 
				
			

GO
